UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T54zJ5ptNxVcvPikUij3uO6y3hSLSPJHiWTC6dqnHY8='
WHERE
key_id = '64d532404acca43e492405f62b715963a6db5d1c5b83143f8f8faa0724a70a52'
AND (
token = 'T54zJ5ptNxVcvPikUij3uO6y3hSLSPJHiWTC6dqnHY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)