UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Dtw0/E4sGyX2N+sQ2KVtuIamOJPJgmg8vuDflqoQpBA=' 
WHERE 
  key_id = 'e6b2be9a493726c934ba9b39c757c04f9dbbafa267e54c9bc93b706e5f6de620' 
  AND (
    token = 'Dtw0/E4sGyX2N+sQ2KVtuIamOJPJgmg8vuDflqoQpBA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021