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