UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JTnRmvQiSJtb16yQo0EBs4C+jr+pwhSvXryKeL4V2gM='
WHERE
key_id = 'd2484080565a9368def82654c6aeb62002c53ced249756e9cd724337d842bd6b'
AND (
token = 'JTnRmvQiSJtb16yQo0EBs4C+jr+pwhSvXryKeL4V2gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)