UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ct7k31ilK24Yn1BSnzjijBEWhOpowx4zkhB8yEcg9M4='
WHERE
key_id = '3e71f317af6d27c7050bed154be946d0dcc47481ea9196e3b5de1a84b36dd993'
AND (
token = 'ct7k31ilK24Yn1BSnzjijBEWhOpowx4zkhB8yEcg9M4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)