UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFrD5yELWvVg4eSra7zYeV0kCGYjzFXF0M1vDIBswZg='
WHERE
key_id = '64c821ba5d0a527ef40dd1a1f0db552a9a669956eebc0b69f3e120925256f0c5'
AND (
token = 'BFrD5yELWvVg4eSra7zYeV0kCGYjzFXF0M1vDIBswZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)