UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9BwKZL8G3iyIiSoUwutwDKqQkzFhy1RpQVFCg31TOhY='
WHERE
key_id = '096ec0a5ba7da54a7e752a2225d12a34465751b642c7680b2aef2ea20ec33505'
AND (
token = '9BwKZL8G3iyIiSoUwutwDKqQkzFhy1RpQVFCg31TOhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)