UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm4E7Th+gC75Yn9ifd+SOENjsQfaUakst+Am4DiivXYI=' 
WHERE 
  key_id = 'b659c83160f1ee9edfe6873c2bff70b677bcf535c2ef4a0df7b3ba8d58aea532' 
  AND (
    token = 'm4E7Th+gC75Yn9ifd+SOENjsQfaUakst+Am4DiivXYI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031