UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7f/8CAH7wO5eN1OZhsoXVt0Z850RsImzjIqeeEI9nns='
WHERE
key_id = '30bedd6f87ee72e4eb0198fdb436bbd1912981b6c18ee197c7d8fa640d7cb93b'
AND (
token = '7f/8CAH7wO5eN1OZhsoXVt0Z850RsImzjIqeeEI9nns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)