UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VOMLYXgagE/4RRtMhD5hngi9rUX/zM8PKZ+QNw83qbo='
WHERE
key_id = '7f81aa0b53e4b70f8ff80365915b99805f272acd172b8ae6cd9780187cec98ae'
AND (
token = 'VOMLYXgagE/4RRtMhD5hngi9rUX/zM8PKZ+QNw83qbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)