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