UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xlz+q4vCpUwyyGcLArVgRZzHNUBXefJZXwalPNrWkO4='
WHERE
key_id = 'd156ca73358100cc9b4be13cfcec54ca8e7188a190b8ddea534a154a69268c90'
AND (
token = 'Xlz+q4vCpUwyyGcLArVgRZzHNUBXefJZXwalPNrWkO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)