UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IgdcuHHFPEkFj2peUnfR/cocfpvs4KjSYnEzvkUZuIw=' 
WHERE 
  key_id = '1abc1f6e9f8e8ca24f6d72be829671b6fdbef7f6c789af19b8997b24d76060bf' 
  AND (
    token = 'IgdcuHHFPEkFj2peUnfR/cocfpvs4KjSYnEzvkUZuIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040