UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G16LDA8R1oYk2tQhKbcSst82CO8DPwPZ1izdEgTNcN8=' 
WHERE 
  key_id = 'deb2571a8d937838a74848bbb8897ab7ab5b3fb98a6b0eaf4c2e1d7b2c8d0a07' 
  AND (
    token = 'G16LDA8R1oYk2tQhKbcSst82CO8DPwPZ1izdEgTNcN8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045