UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LhVrSZsVtENkyfC9o23I7oX6g/00Ja8t6Y7JWMFRJXo=' 
WHERE 
  key_id = '30c933640982fb5b9c867dafd300320b158e535ed5dd7ec394c0722dfc9f9992' 
  AND (
    token = 'LhVrSZsVtENkyfC9o23I7oX6g/00Ja8t6Y7JWMFRJXo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044