UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5OekkR4z99ozEC19zcqABlbizEXs5X4N7dnK5/AzYv4=' 
WHERE 
  key_id = '31b0f1febb35401897413b7897d7921f6b76bd3c2a0f1f191d3e916db6d367b0' 
  AND (
    token = '5OekkR4z99ozEC19zcqABlbizEXs5X4N7dnK5/AzYv4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018