UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HbzsnZwEU0K6UOgiIEEcWuYG73k+fo8qC2JF5raNLBw=' 
WHERE 
  key_id = '99d7f05f97976a1ca87bfec0fe8ce1d77f8ee00c038da160d2d5ec99ccd64d13' 
  AND (
    token = 'HbzsnZwEU0K6UOgiIEEcWuYG73k+fo8qC2JF5raNLBw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043