UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2D0X55A8FdasAgtZcEs7RrYw0urGAmcoHixCN8486P8=' 
WHERE 
  key_id = '64ce93abfa90ad9a96c7c88ad4a698a3a839d3323fd75fbff4aa2c346fc0e462' 
  AND (
    token = '2D0X55A8FdasAgtZcEs7RrYw0urGAmcoHixCN8486P8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043