UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4q0FtT+O9CYMf6NvSNp9PXgQXaoPAbJjGCSPmv1hYuU='
WHERE
key_id = 'dd2b144dd255e88aa90fd9be8b2e08713430a21b856f9ee963853dd9fa7e985d'
AND (
token = '4q0FtT+O9CYMf6NvSNp9PXgQXaoPAbJjGCSPmv1hYuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)