UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMo4dTIdnlECGuwTNzQt42cu4/2HYIe2cXRTmXp/i2M='
WHERE
key_id = '4b0597765a3e5fd582e1b9ae256f5b3fd9a2f9165e4b72e66d7acb4400c627ef'
AND (
token = 'nMo4dTIdnlECGuwTNzQt42cu4/2HYIe2cXRTmXp/i2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)