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