UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5WyzgRlEOZ6zYy2Li1w+ynVAGfiEGWcvlAH7vK8TmSM='
WHERE
key_id = '78a237eccd09117b79a44a76ce05019b3508e5850ed5882f4900df7a59bad9cc'
AND (
token = '5WyzgRlEOZ6zYy2Li1w+ynVAGfiEGWcvlAH7vK8TmSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)