UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dj3SjyYGocmd6XkrDZX16Az6Vgnj6U58wkEQi798R9M='
WHERE
key_id = 'd82be29960cb1d336b5dddada0484792ced22590bf417bd41d8f4536d8a2ffd4'
AND (
token = 'Dj3SjyYGocmd6XkrDZX16Az6Vgnj6U58wkEQi798R9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)