UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AooL4JncpDOjRFa0nwrYW4sCgwYYKV0yd+3YLl903SM=' 
WHERE 
  key_id = 'c55231d96ea20a91926e5723e79a54e8d03bf8c54cc4a7ed370560cc9b4f8bfc' 
  AND (
    token = 'AooL4JncpDOjRFa0nwrYW4sCgwYYKV0yd+3YLl903SM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032