UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qd8YTkqGbIROvk6SlC7v3lzvrSlQIwwX3uHXB8/gVYg='
WHERE
key_id = '0e819e92e253a66569ccaaa91c11ea6e7bc0f67183c2acd1fafb8b3ae290788a'
AND (
token = 'qd8YTkqGbIROvk6SlC7v3lzvrSlQIwwX3uHXB8/gVYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)