UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQdVgWU0bkZtXN4pd/dJhs84hFjkPA3Ywgwus9hGNG4='
WHERE
key_id = 'bd8d9f4955795fa40187dda7c1f59a10c7ca998e9b608644c724222895854fc3'
AND (
token = 'fQdVgWU0bkZtXN4pd/dJhs84hFjkPA3Ywgwus9hGNG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)