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