UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2O2sA1/aw+E/9G24mjL0JX5X4JDXxkg4T8kG2UhcadM=' 
WHERE 
  key_id = '6f05a28a1956d3268e8583d672092fdee76124cdf66f050be8722826ecb33f43' 
  AND (
    token = '2O2sA1/aw+E/9G24mjL0JX5X4JDXxkg4T8kG2UhcadM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024