UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2LfJg3r2flg9lc0OBwpESXNEzo/GS9Yz57mYIaGnH4k='
WHERE
key_id = 'dd18f71b28f2841ef3099d5af272c4163348a5a6a9b413ae540557fbe044822b'
AND (
token = '2LfJg3r2flg9lc0OBwpESXNEzo/GS9Yz57mYIaGnH4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)