UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tid6w2tSuIhIYGvWOo5tw9d71PxUbclzzU+E1W5zU4='
WHERE
key_id = 'dd8e3b462d3a17689b3f5e986e352e5eac83389e61f57e4f77d5a356411cee4f'
AND (
token = '7tid6w2tSuIhIYGvWOo5tw9d71PxUbclzzU+E1W5zU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)