UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GvYbeKBE9Irodi0dMLq8LFEPC5vCnoAuUvyflK4kdBA='
WHERE
key_id = '37b75bde88999b925e6cd7efc71b1a1a42566efb23c8249daeb50e007d80999d'
AND (
token = 'GvYbeKBE9Irodi0dMLq8LFEPC5vCnoAuUvyflK4kdBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)