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