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