UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KN6ZORIGc+XHQq/GtjTWJBMzUs7YYSF2FpX+9FnIrOw='
WHERE
key_id = 'f6e646eb8dff425fe72922ac00a640f2525502e71d13e7b94ffdf15fcfff9d3d'
AND (
token = 'KN6ZORIGc+XHQq/GtjTWJBMzUs7YYSF2FpX+9FnIrOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)