UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HfAq2xfxo8F18c50Zt2yc1N74lL0Yxc6Q1dAG3yuCH0=' 
WHERE 
  key_id = '9dcf68bbfe35b0795379dbcc5a0e1810c9122c8dcedea7ec4644547cee4ffb77' 
  AND (
    token = 'HfAq2xfxo8F18c50Zt2yc1N74lL0Yxc6Q1dAG3yuCH0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019