UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OtZIKlYPkZ38S+gQlIn8my1pJOhyTY9LVZo6hJs8ROo='
WHERE
key_id = '46f2acf04346a56c350e5b197666b0b82d77bdd539fab747261ef3a57503527d'
AND (
token = 'OtZIKlYPkZ38S+gQlIn8my1pJOhyTY9LVZo6hJs8ROo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)