UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3wUQ/qbr7rcd8jv7GI8va/Ku2jYCAcB0sZKwwPHIAug=' 
WHERE 
  key_id = '0d566f54b4ab901f0ba2aa0c786801e991e8de28376a8b168e4ab5e26b9b90fa' 
  AND (
    token = '3wUQ/qbr7rcd8jv7GI8va/Ku2jYCAcB0sZKwwPHIAug=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024