UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FrJQRUCI6AWVjaL9/N2IzdsVit993kGi+w+VMHrYBkE=' 
WHERE 
  key_id = '96ed448332e9a62c2e3cb4dec44e135ee262193c32fe015cf5f6f29bd6f13c11' 
  AND (
    token = 'FrJQRUCI6AWVjaL9/N2IzdsVit993kGi+w+VMHrYBkE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024