UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oOlU5LV7+De2Aa/Jju3M3gdI6ZBrjI4mV53kbj8Rdo0='
WHERE
key_id = 'aa39c8d748cc98d34d8cf40d6a324d9871cdf76ebe4cd5ed655a5ac5e513e15f'
AND (
token = 'oOlU5LV7+De2Aa/Jju3M3gdI6ZBrjI4mV53kbj8Rdo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)