UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WHRwL6xCtfgdPdIwuadulpi0TIlp8u39i/Jsfqc+I8I=' 
WHERE 
  key_id = '664c0d96984e15937dbd623e704d5acee111ca11e044d65e23b28efd57b82fe1' 
  AND (
    token = 'WHRwL6xCtfgdPdIwuadulpi0TIlp8u39i/Jsfqc+I8I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022