UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '03gdHBTz8beShDr6ip8baYRw6uoEc1hDF+e2VF05HPY='
WHERE
key_id = '0868e7027549c65da054d6eadfb718528a7f03194624a87351d96659c57e93ee'
AND (
token = '03gdHBTz8beShDr6ip8baYRw6uoEc1hDF+e2VF05HPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)