UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'o0+RjW63Zk8bk7Kr5s/GuMp1wY69Bh5TxmDdpk5f/nI=' 
WHERE 
  key_id = 'fa37d94a861b45f301294a77c8096ab830f57c1b8ab510151f984fecfe3e7262' 
  AND (
    token = 'o0+RjW63Zk8bk7Kr5s/GuMp1wY69Bh5TxmDdpk5f/nI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045